-
Re: How to trigger dropdown to populate projected completed date based on specific complexity?
@NBKD You could add a column ("Record Date: Complexity"), then set up an automation to fill that column with the date that "Complexity" is changed to one of the dropdown values, a…1 · -
Re: Month to Number
@Angela L The basic idea of the formula that Itai provided is the one to use. However, since the month is just a text string, you don't need the month function (which works on dates, not text). Try t…2 · -
Re: Sum of column values that come from function formula
@Victorugo Contreras You are very welcome! 😊1 · -
Re: Date Calculation Formula to Return Friday of Week Calculated
This may not be the most elegant solution, but it gets the job done for me. First, place a helper column with the formula below; in this example the helper column is named "Column": =WORKDA…6 ·